package com.yu.waterstation.app.moudles.address.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yu.waterstation.common.entity.app.Address;
import com.yu.waterstation.common.entity.app.vo.AddressStudentVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface AddressMapper extends BaseMapper<Address> {

    // 获取寝室成员
    @Select("select student.id as studentId, student.`name` as studentName, student.wx_avatar as wxAvatar " +
            " from student where address_id = #{param1}; ")
    List<AddressStudentVO> getAddressStudents(Integer addressId);
}
